﻿using System;
using Kwan.Data.Mappings;
namespace ZP.Data
{
    [Table("ZP_Job LEFT OUTER JOIN ZP_Company c ON ZP_Job.CompanyID = c.EntityID"+
        " INNER JOIN ZP_City city ON ZP_Job.Jobarea = city.Code" +
        " INNER JOIN ZP_Funtype fun ON ZP_Job.Funtype = fun.Code" +
        " INNER JOIN ZP_Industry ind ON c.IndustryCode = ind.Code"
        )]
    public interface IVJob
    {
        [ID("ZP_Job.EntityID")]
        [IDENTITY]
        int EntityID { get; set; }
        [Column("ZP_Job.CompanyID")]
        int CompanyID { get; set; }
        [Column("ZP_Job.ContactPerson")]
        string ContactPerson { get; set; }
        [Column("ZP_Job.Click")]
        int Click { get; set; }
        [Column("ZP_Job.Degreefrom")]
        string Degreefrom { get; set; }
        [Column("ZP_Job.Description")]
        string Description { get; set; }
        [Column("ZP_Job.Duty")]
        string Duty { get; set; }
        [Column("ZP_Job.EndDate")]
        DateTime EndDate { get; set; }
        [Column("ZP_Job.Enrollments")]
        string Enrollments { get; set; }
        [Column("ZP_Job.Funtype")]
        string Funtype { get; set; }
        [Column("ZP_Job.Issuedate")]
        DateTime Issuedate { get; set; }
        [Column("ZP_Job.Jobarea")]
        string Jobarea { get; set; }
        [Column("ZP_Job.JobName")]
        string JobName { get; set; }
        [Column("ZP_Job.Jobterm")]
        string Jobterm { get; set; }
        [Column("ZP_Job.Match")]
        string Match { get; set; }
        [Column("ZP_Job.Providesalary")]
        string Providesalary { get; set; }
        [Column("ZP_Job.Scale")]
        string Scale { get; set; }
        [Column("ZP_Job.Sex")]
        string Sex { get; set; }
        [Column("ZP_Job.Workyear")]
        string Workyear { get; set; }
        [Column("c.CompanyName")]
        string CompanyName { get; set; }
        [Column("c.Employees")]
        string Employees { get; set; }
        [Column("c.Email")]
        string Email { get; set; }
        [Column("c.Type")]
        string ComType { get; set; }
        [Column("c.Scale")]
        string ComScale { get; set; }
        [Column("c.Memo")]
        string ComMemo { get; set; }
        [Column("fun.Name")]
        string Fun { get; set; }
        [Column("ind.Name")]
        string Industry { get; set; }
        [Column("ind.Code")]
        string IndustryCode { get; set; }
        [Column("city.Name")]
        string City { get; set; }
    }
}